#! /bash/bin
db_name=fujunhua
hive -e "
use $db_name;
create table app_hot_rank(
tag string comment 'tag',
num string comment '标签的数量',
rank string comment '排名',
percentage string comment '百分比',
all_num string comment '总数'
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t' 
LINES TERMINATED BY '\n'
STORED AS textfile;
"
